package com.example.qxfw.ybzz.mapper;

import com.baomidou.dynamic.datasource.annotation.DS;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.qxfw.common.entity.zy.TourStations;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
@DS("service")
public interface TourStationsMapper extends BaseMapper<TourStations> {

    @Select("select StationID, StationName, Longitude, Latitude from tour_stations")
    List<TourStations> selectStation1();

    @Select("select StationID, StationName, Longitude, Latitude, Altitude " +
            "from tour_stations " +
            "where stationid is not null")
    List<TourStations> selectStation2();

    @Select("select stationname,text,stationid " +
            "from tour_stations " +
            "where stationId = #{stationId}")
    List<TourStations> selectStation3(String stationId);

    @Select("select stationName from tour_stations " )
    List<String> selectStationName();
}
